Design a SOFA report layout

This example show you how to create a layout which produces a report with the basic elements below:

Create a new layout

Open: Settings > Cash Book / Nominal Ledger > Financial Statement Layouts.

1. Choose New.
2. Enter a name for the layout
3. Click Edit.

Tip: If you just want to amend the sample layout we've provided, copy the sample layout and make any required changes. See Amend the financial report layouts.

Add your income and endowments

1. Create a text line for your first section.
   1. Choose Text from the Type drop-down list.
   2. Enter the heading text in the Title column, e.g. Income and endowments from.
   3. Choose a heading style: 1 - 9.
2. Choose the SOFA categories to include in your first section. These are the Income SOFA categories.
   1. Choose Single Account Group from the Type drop-down list.
   2. Choose the SOFA category code from the drop-down list; e.g. SI01 for Donations and capital grants.
   3. Change the Title if required.
   4. Choose Credit from the Debit/Credit drop-down list.
3. Add additional text lines where required. You can also add blank text lines. For example, Charitable Activities.

4. Repeat for all Income SOFA categories.

5. Create a total for the section.
   1. Choose Sub Total from the Type drop-down list.
   2. Enter some text in the Title column, such Total income and endowments. The text is bold by default.

   3. Choose 1 in the subtotal level, as this adds up all rows above not included a sub total. This totals up your income.

Add your expenditure

1. Create a text line for the section.
   1. Choose Text from the Type drop-down list.
   2. Enter the heading text in the Title column, e.g. Expenditure on.
   3. Choose a heading style: 1 - 9.
2. Enter the SOFA categories to include in this section. This is for your expenditure so add Expense SOFA categories.
   1. Choose Single Account Group from the Type drop-down list.
   2. Choose the SOFA category code from the drop-down list; e.g. SE01 for Raising funds.
   3. Change the Title if required.
   4. Choose Debit from the Debit/Credit drop-down list.

3. Repeat for all Expense SOFA categories.

4. Create a total for the section.
   1. Choose Sub Total from the Type drop-down list.
   2. Enter some text in the Title column, such Total Expenditure. The text is bold by default.

   3. Choose 1 in the subtotal level, as this add up all rows above not included in a sub total.

      As your income is already included in a subtotal above, this totals your expenses only.

   4. Choose Debit from the Debit/Credit drop-down list.

Calculate the net income / expenditure

1. Choose Sub Total from the Type drop-down list.
2. Enter some text in the Title column, such as Net Income/ (expenditure).

3. Choose 2 for the subtotal level. This adds all rows above not included in a level 2 subtotal.

   As this is the first subtotal level 2, all your income and expenses rows are added together. As income is a credit value and expenses a debit value, the expenses are effectively subtracted from the income.

4. Choose Credit from the Debit/Credit drop-down list.:

   If your expenses are more than your income, the value is displayed in brackets.

Add your fund transfers and other gains and losses

This is the total of any journals recorded for fund transfers and other recognised gains and losses, typically defined pension schemes.

1. Enter a blank line.
2. Add the SOFA category for fund transfers.
   1. Choose Single Report Group from the Type drop-down list.
   2. Choose the SOFA category code from the drop-down list; e.g. SX97 for Transfers between funds.
   3. Change the Title if required.
   4. Choose Credit from the Debit/Credit drop-down list.
3. Create a text line for the section.
   1. Choose Text from the Type drop-down list.
   2. Enter the heading text in the Title column, e.g. Other recognised gains/ (losses).
   3. Choose a heading style: 1 - 9.
4. Add the SOFA categories for your other gains and losses
   1. Choose Single Account Group from the Type drop-down list.
   2. Choose the SOFA category code from the drop-down list; e.g. SX98 for Actuarial gains/(losses) on defined pension schemes.
   3. Change the Title if required.
   4. Choose Credit from the Debit/Credit drop-down list.
5. Create a total for the section.
   1. Choose Sub Total from the Type drop-down list.
   2. Enter some text in the Title column, such Net movement in funds. The text is bold by default.

   3. Choose 1 in the subtotal level, as this adds up all rows above not included in another subtotal.

      As your income and expenses are already included in subtotals above, this totals this section only.

   4. Choose Credit from the Debit/Credit drop-down list.

Add your brought forward funds

1. Add a text line

   1. Choose Text from the Type drop-down list.
   2. Enter the heading text in the Title column, e.g. Reconciliation of funds.
   3. Choose a heading style: 1 - 9.
2. Add the SOFA category for brought forward funds.
   1. Choose Single Report Group from the Type drop-down list.
   2. Choose the SOFA category code from the drop-down list; e.g. SX99 for Funds brought forward.
   3. Change the Title if required.
   4. Choose Credit from the Debit/Credit drop-down list.

Calculate your total funds carried forward

1. Choose Sub Total from the Type drop-down list.
2. Enter some text in the Title column, such as Total funds carried forward.

3. Choose 3 in the subtotal level, as this adds up all rows above not included in a level 3 subtotal.

   This totals your income, expenses, fund transfers, other gains and losses and brought forward funds, crating your funds carried forward figure.

4. Choose Credit from the Debit/Credit drop-down list.

Use the new layout to print your SOFA report

Open: Nominal > Nominal Reports > Financial Statements.

1. Choose the Statement of Financial Activities.

2. Choose the new layout from the Report Name in the report criteria. This will default to the first layout in the list (sorted alphabetically).

   Tip: If you want to make sure a certain layout is always used, change the layout name to make sure it's the first one listed.